UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wxw8omx7OHk/R8B307N7/5Q4epW6/CFIY2CJUF+Ev00='
WHERE
key_id = '0bfe8e6600133b40d7520c9cc7b5c3cba7b9a0495888d8af413cac46bfcc9b91'
AND (
token = 'wxw8omx7OHk/R8B307N7/5Q4epW6/CFIY2CJUF+Ev00='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)