UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XiLGmY3g2i3vXap0Y5u5DJQPuCKpfLeFioNGKtvh4i8='
WHERE
key_id = '531e19424d523a58a12dba716d2c66d3ebeb1442696d81a9ba6ac7439ed87747'
AND (
token = 'XiLGmY3g2i3vXap0Y5u5DJQPuCKpfLeFioNGKtvh4i8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)