UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x7I1fD4NVs4dXhQEDF8mSt1BO3a7fE5gg3LemLn8kGo='
WHERE
key_id = '5b1c7ef017818347d992f2f837a7c5288f1712abd8d53ecc0d43f87cbb46c404'
AND (
token = 'x7I1fD4NVs4dXhQEDF8mSt1BO3a7fE5gg3LemLn8kGo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)