UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Qp9pOUReiBtj2sY6fuZ1dsa91fYyOT+bHiGjwwwTGc4='
WHERE
key_id = '03096dac4dd6cabf6c866f613bb68b7a1d52402cbfddbe28e69d2afcf3f3746e'
AND (
token = 'Qp9pOUReiBtj2sY6fuZ1dsa91fYyOT+bHiGjwwwTGc4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)