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