UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1aNUV6FKlo8H37M4fEq5P8iIMRfa/FyYmggbe1Okiz0='
WHERE
key_id = '47d62cc17655d3b96793d02d69c888c1d73be9319152ae6c48ad7a5213ec8cd6'
AND (
token = '1aNUV6FKlo8H37M4fEq5P8iIMRfa/FyYmggbe1Okiz0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)