UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'beP3xI79n6apbY3XuVEY4v/1lFdVWNXsf8e9tkZ5jEs='
WHERE
key_id = 'f674438b7506a9593d8381cf8c4944a12edaf88c6a8671ef53702ccd2bd7a93a'
AND (
token = 'beP3xI79n6apbY3XuVEY4v/1lFdVWNXsf8e9tkZ5jEs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)