UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MGI9AFeMX5y4azR7nmDP4+tqpbnowCYQcpHF4QHMAzM='
WHERE
key_id = 'a1e9247ad909ee519a2349f30767ef3765ae656f0c18661144c22d7e62139099'
AND (
token = 'MGI9AFeMX5y4azR7nmDP4+tqpbnowCYQcpHF4QHMAzM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)