UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U0/gIztY5wVarHxWRNQAXc1XHKl21bJmxKU6vW7Ahsg='
WHERE
key_id = 'bdf78cba99f7a21cf94a5141905c21f8d7bbe238e3a2d139d6bbd9fe6b8c6c48'
AND (
token = 'U0/gIztY5wVarHxWRNQAXc1XHKl21bJmxKU6vW7Ahsg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)