UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S4itKEE9rUC9qYe0IDnMRKONi3WVVD1H6dKSmt3jrMU='
WHERE
key_id = '0c1f937b1c25facd7d7707c4f4fb42c0797d69ecc2684c01c0c1d38c611cdd51'
AND (
token = 'S4itKEE9rUC9qYe0IDnMRKONi3WVVD1H6dKSmt3jrMU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)