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