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