UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VPTX5jxJUC4E38sMq5HaXstUyN4BPpOcvAwFy/FRe10='
WHERE
key_id = 'f64adc727b2648e28ee6cbad9990bd2612210368ecf5e89c227d5c6ca6a4e136'
AND (
token = 'VPTX5jxJUC4E38sMq5HaXstUyN4BPpOcvAwFy/FRe10='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)