UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XZ8dM9a8rqgFIOtgFzXZDmrL8DrAZL0XKoSTjmn4QxQ='
WHERE
key_id = '56fdf0515041cbca372de0b31e74e5c76884fae8a8cfab4b4ad175d74d27be12'
AND (
token = 'XZ8dM9a8rqgFIOtgFzXZDmrL8DrAZL0XKoSTjmn4QxQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)