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