UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uI6dRCRrUjuce1LiRknkLKHQs1GIPxl/EICYWmhujJ8='
WHERE
key_id = 'd9ccc1e9dbf3dd95676b5ae3408f8c5d6848b96c38334eb6603d8d04fb200a65'
AND (
token = 'uI6dRCRrUjuce1LiRknkLKHQs1GIPxl/EICYWmhujJ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)