UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EcSzhbHPX3XGiOurzHvD1TuSKS3cYVzZ7eEWI/9UK0U='
WHERE
key_id = '19f6d67a6efba5b058cfe9b7ddafa149ff18f25c31ab8db00b005d92ff9a5ad8'
AND (
token = 'EcSzhbHPX3XGiOurzHvD1TuSKS3cYVzZ7eEWI/9UK0U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)