UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UNGz5Pnbu7Qjd1jHA7wIcbobifxyqGmjYQlXZDm5XYc='
WHERE
key_id = '9d05fdf27cec37f603c3c4167185667e2bd114556116c23a1eb2f5c273dda3b7'
AND (
token = 'UNGz5Pnbu7Qjd1jHA7wIcbobifxyqGmjYQlXZDm5XYc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)