UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rgzT6Ef4lO4QunotKHE880KlFqAH/569Q4eYXWewabo='
WHERE
key_id = '7b5ae0486d87ad86ab965595b254a6624f0afb8f890fa73685243dc802ca41bd'
AND (
token = 'rgzT6Ef4lO4QunotKHE880KlFqAH/569Q4eYXWewabo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)