UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eOIKRv2ID0EVpMRU1KDi04YfNJ2CwwWbjT29VD8jL08='
WHERE
key_id = 'a0f3fd3f2cef9475044043c586224bcac975bf875e5df47b46cf13c404192222'
AND (
token = 'eOIKRv2ID0EVpMRU1KDi04YfNJ2CwwWbjT29VD8jL08='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)