UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jk0r4esJyRt3x2LGhTXh4wi1UVt6DheuUwCE5k06OsU='
WHERE
key_id = '96c9393fdec81afe78be0810d3f893f5145b544e6831e8688c8afc2517158e40'
AND (
token = 'jk0r4esJyRt3x2LGhTXh4wi1UVt6DheuUwCE5k06OsU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)