UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VP9QeWDb7QucYPYjSqZJlwpw3XPK0nBwSGpjPaDIqKo='
WHERE
key_id = 'b934511f1bc855d7d202315c07be4d15cc3abf85d9e4bced2468cd05efe20247'
AND (
token = 'VP9QeWDb7QucYPYjSqZJlwpw3XPK0nBwSGpjPaDIqKo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)