UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WZh4fcHM78ux0s+QW42jgEBha8ZaDcI2BfcHTd4+rZw='
WHERE
key_id = '1819c2a5faf87e9f5c49d7c5a41d5aa00d72e354b51e31f7dca8043fab788fd9'
AND (
token = 'WZh4fcHM78ux0s+QW42jgEBha8ZaDcI2BfcHTd4+rZw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)