UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mZzBq/+PA/ADhdLjnPkIAm36Xu6w3ovIYG/N+LF/A30='
WHERE
key_id = '78d7accbf38d215b17a262397df0012f25f64055600109d4555aec8038d66b9c'
AND (
token = 'mZzBq/+PA/ADhdLjnPkIAm36Xu6w3ovIYG/N+LF/A30='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)