UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+pevQ602eyIpJC9sPEugHQ2dn5vDkabUqGpApQHjwAY='
WHERE
key_id = 'b708f6ee491c2d98303ac2f6a1f6170fa9b47a3ee5453c40cc867c801ef18a40'
AND (
token = '+pevQ602eyIpJC9sPEugHQ2dn5vDkabUqGpApQHjwAY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)