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