UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gQY0FsK4g2xeYv3JDwchnBq2eeJEmosyGhoVkUkuUdY='
WHERE
key_id = 'a20f53d889fc159ace5910d0d511f9e62c55ff6828d9a35abfedf76494a4ef65'
AND (
token = 'gQY0FsK4g2xeYv3JDwchnBq2eeJEmosyGhoVkUkuUdY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)