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