UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VZ3eGQCYQguUTeUvmVMqsZY3JLoJBcYcVTF0gDhBgL0='
WHERE
key_id = '4b1073e7a9f0000058e6d325a341650ccdf60a5ebc376e1e460612c8fd716fad'
AND (
token = 'VZ3eGQCYQguUTeUvmVMqsZY3JLoJBcYcVTF0gDhBgL0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)