UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fZ1nfSNC7+OCfvsWuwiJr1OkX160JCYxTzjcXIUPxSI='
WHERE
key_id = 'b55c81ca6ac08831fc692d6a614dbb1b1ce59db5e42015f2e979f634642c47c7'
AND (
token = 'fZ1nfSNC7+OCfvsWuwiJr1OkX160JCYxTzjcXIUPxSI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)