UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PYQZ43D9kAjdYACqjM52rIYbwbksi6qGArQTIfUtZSE='
WHERE
key_id = 'fceee9b861fb850e361ca1de65aaa92a982794136471c6604399025ec8767b35'
AND (
token = 'PYQZ43D9kAjdYACqjM52rIYbwbksi6qGArQTIfUtZSE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)