UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cs8WH4Ii/6d1I2sXu29FgBbCklkhLLNfyF/oqAp+z5E='
WHERE
key_id = 'bc782e2c19d32e4297f842c2487491660a80980fb935df8bd029fc13438bb308'
AND (
token = 'cs8WH4Ii/6d1I2sXu29FgBbCklkhLLNfyF/oqAp+z5E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)