UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aeL/+bq3f0B30HFswKjf40ll5IQn8nheHvqlf1TEFbg='
WHERE
key_id = 'b86f7b60eb476948e15fb22a87fd4bd619d2e9b8f995b7170a82571f3ab04b5f'
AND (
token = 'aeL/+bq3f0B30HFswKjf40ll5IQn8nheHvqlf1TEFbg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)