UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VGl336snJP4H1KDpwfqNmI36h9a5MdHpjaj9ecjSZuc='
WHERE
key_id = '29d4005f2299d55c1d9fc3b3d2a8a79b24b767cc87cf9f86849368a19bf4ea15'
AND (
token = 'VGl336snJP4H1KDpwfqNmI36h9a5MdHpjaj9ecjSZuc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)