UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xq9hea0ryXmqJ2d/jshuhWIYtV2p9ogFAbD8BLz9NUE='
WHERE
key_id = '48bc21ac55c9b4079e2f23521484a19de32ece97912751e1294b8ca5e827476e'
AND (
token = 'Xq9hea0ryXmqJ2d/jshuhWIYtV2p9ogFAbD8BLz9NUE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)