UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YWQjylNk8drS/eWEtyEcEBXNpUB4TWD8+9p80n+wATg='
WHERE
key_id = '2a17ee789058709177a4febd80e6dbf3b141b5ccb455f04346f4c269bd93bc34'
AND (
token = 'YWQjylNk8drS/eWEtyEcEBXNpUB4TWD8+9p80n+wATg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)