UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XPPftdmF5VI95MH8FjZg9oO02LZCuq9PDuJFFd1vDWo='
WHERE
key_id = '937304d630b6a317ee99863c5ae8e77ae2d12a5d2d736114438a83e0616a7d6b'
AND (
token = 'XPPftdmF5VI95MH8FjZg9oO02LZCuq9PDuJFFd1vDWo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)