UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1G8NyKvWQEOFnTXv7REcQPj5BB/LHTQSpC9GZZS6UNA='
WHERE
key_id = '4b617c4b0063623483d8e04ea27c2c29862fbb068f671e88261d2462ff1f95bc'
AND (
token = '1G8NyKvWQEOFnTXv7REcQPj5BB/LHTQSpC9GZZS6UNA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)